Error 2174 you can't switch to a different view at this time occurs we tried to switch between views. Error 2174 occurs, if you are debugging code, you must end the debugging operation before switching views. In this article we are explain the reason of error 2174 error. Suppose we are open a form, by default its open in form view. But if we want to change the form view to datasheet view, then we have to use macro code to open same form with datasheet view. After write macro, when we open the form, the run time error '2174', you can't switch to a different view at this time as shown in Fig 1.1.

Resolution: We can avoid this error by using error handling techniques. Or we have to set property sheet values. We have to allow datasheet view Yes and allow Form View to No. So using this we can avoid the error. And also we don't need to write code for that because it's already in datasheet view.

To reproduce error we have to allow Form view Yes and on open event, write macro for open same Form in datasheet.

VBA code On Open event:

Private Sub Form_Open(Cancel As Integer)
DoCmd.OpenForm "Form1", acFormDS
End Sub